<?php

include_once "boot.php";

$ar_filters = array(0=>array('var'=>'officeCode', 'val'=>'1'));
$ar_orderby = array( 'fulltime'=>'DESC', 'lastName'=>'ASC');
$ar_limit = array('start'=>0,'limit'=>5);
?>

<pre>
<?php
print "ar_filters \n";
print_r($ar_filters);

print "\n ar_orderby \n";
print_r($ar_orderby);

print "WITH source \n";
$ar_data = get_array_query_full("SELECT * FROM employees WHERE 1  " ,array(0=>array('var'=>'officeCode', 'val'=>'1', 'source'=>'employees')),$ar_orderby, $ar_limit);
print_r($ar_data);


$ar_orderby = array( '`employees`.`fulltime`'=>'DESC', 'lastName'=>'ASC');
print "Without source \n";
$ar_data = get_array_query_full("SELECT * FROM employees WHERE 1  " ,array(0=>array('var'=>'officeCode', 'val'=>'1')),$ar_orderby, $ar_limit);
print_r($ar_data);
?>
</pre>